Visualize Key Insights/Key Takeaways 24
********************************************************************

Visual Key Insights / Key Takeaways
********************************************************************


1st go back and review the Visualize Key Insights section earlier in the documentation.  If you used the Project Checklist while working through your project, you probably already have most of this complete.  Now is the time to make it look good and present.

Two Sections:

Key Insights

                       KPI

                       Good or Bad

                       Responsible Dim

                       What is good/bad

                       Where is occurred

                       When it occurred

                       The Extent of the good/bad

                       How I know it is good/bad

Proof

                       a.  Create a  GIF showing filters on for "Extent" and moving to "How I know" selections.  You can also do it reverse by showing "How I know" selection 1st.  Either way the gif will back and forth from both set of selection groups so the audience can see the insight in your gif

                       b. Screenshot of your nicely formatted SQL code with the results.  The numbers used in "Extent" should be highlighted in the screenshot.



Words of Wisdom

More often than not you will want to  use Date Comparisons such as

These comparisons are very good when  showing movement or which direction something is headed.  When you try to explain these in your insight, below is a guide of how to explain so people can understand

March 2020 YoY = 60%

March 2020 MoM = -10%

Sometimes it can be tricky revealing this information in a way where people can understand . Hopefully the above examples help.





Instructions:

  1. Assign this task to yourself.
  2. Once you have read through this task and you fully understand it, write a small paragraph with screenshots and notes of what you learned.  Then add it as a comment on this task.
  3. Everyday you work on this task, you will add a minimal of a comment and a screenshot.  Gifs are good as well.
  4. Note: You as well as other people will be reading through your project notes.  Make sure you talk about your thoughts at the moment so you and others can relive the experience.
  5. Upon completion, close the task and navigate back to your Colaberry Project Dashboard.













DW Example